{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Agency Information","TESTED Sexual Assault Kits","UNTESTED Sexual Assault Kits","Summary","Cell References"],"read":"whole","date_system":"1900"}

{"sheet":"Agency Information","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"merged":[[10,1,10,2],[15,1,15,2]]}
[]
[null,"Agency Name:"]
[null,"County:"]
[]
[null,"Point of Contact (POC) Name:"]
[null,"POC Phone #:"]
[null,"POC E-mail Address:"]
[]
[null,"Date Audit Completed:"]
[]
[null,"The sexual assault kit audit was reviewed by the following LAW ENFORCEMENT REPRESENTATIVE:"]
[null,"Name:"]
[null,"Title:"]
[null,"Agency:"]
[]
[null,"The sexual assault kit audit was reviewed by the following COUNTY PROSECUTOR:"]
[null,"Name:"]
[null,"Title:"]
[null,"Agency:"]

{"sheet":"TESTED Sexual Assault Kits","index":1,"n_rows":2,"n_cols":5,"rows_kept":2}
["Agency Case #","Date Submitted to Forensic Laboratory","Testing Completed or In Progress","Name of Forensic Laboratory","Was crime committed within Idaho state boundaries?"]
["M14000000 (Example)","2014-10-05","Completed","Idaho State Police","Yes"]

{"sheet":"UNTESTED Sexual Assault Kits","index":2,"n_rows":3,"n_cols":13,"rows_kept":3}
["Agency Case #","Charge","Was crime committed within Idaho state boundaries?","Date Collected","Is this an Anonymous or Unreported (\"Jane Doe\") Kit?","Victim Age","Reason Not Submitted to a Forensic Laboratory for Testing\n(If reason is one of the three options in the drop-down menu then the columns to the right are \"N/A\".  If \"Other\" is selected please explain under the Comments section.)","Was a Victim Reference Collected?","Is There a Named Suspect?","Was a Suspect Reference Collected? (If \"No\" explain under comments)","Did the Victim Have Consensual Sex within 96 Hours?","Was a Consensual Partner Reference Collected?","Comments"]
["M14000000 (Example)","I18-6101 Rape","Yes","2014-10-05","No",19,"Victim expressly indicated that no further forensic examination or testing be performed on the kit","N/A","N/A","N/A","N/A","N/A","None"]
["M15000000 (Example)","I18-6101 Rape","Yes","2015-03-23","No",32,"Other","Yes","Yes","No","No","N/A","Prosecution was declined.  The suspect has moved out of state and cannot be located to collect a reference sample."]

{"sheet":"Summary","index":3,"n_rows":11,"n_cols":3,"rows_kept":11}
[]
[null,"Total # of TESTED Sexual Assault Kits:",{"$f":"COUNTA(Table13[[#All],[Agency Case '#]])-2","v":0}]
[null,"# Completed:",{"$f":"COUNTIF(Table13[[#All],[Testing Completed or In Progress]],\"Completed\")-1","v":0}]
[null,"# In-Progress:",{"$f":"COUNTIF(Table13[[#All],[Testing Completed or In Progress]],\"In Progress\")","v":0}]
[]
[null,"Total # of UNTESTED Sexual Assault Kits:",{"$f":"COUNTA(Table1[[#All],[Agency Case '#]])-3","v":0}]
[null,"# Anonymous or Unreported",{"$f":"COUNTIF(Table1[[#All],[Is this an Anonymous or Unreported (\"Jane Doe\") Kit?]],\"Yes\")","v":0}]
[null,"# No Crime Committed",{"$f":"COUNTIF(Table1[[#All],[Reason Not Submitted to a Forensic Laboratory for Testing\n(If reason is one of the three options in the drop-down menu then the columns to the right are \"N/A\".  If \"Other\" is selected please explain under the Comments section.)]],\"Law enforcment determined no crime was committed\")","v":0}]
[null,"# No Longer Investigated as Crime",{"$f":"COUNTIF(Table1[[#All],[Reason Not Submitted to a Forensic Laboratory for Testing\n(If reason is one of the three options in the drop-down menu then the columns to the right are \"N/A\".  If \"Other\" is selected please explain under the Comments section.)]],\"Law enforcement is no longer investigating as a crime\")","v":0}]
[null,"# Victim Refused Testing",{"$f":"COUNTIF(Table1[[#All],[Reason Not Submitted to a Forensic Laboratory for Testing\n(If reason is one of the three options in the drop-down menu then the columns to the right are \"N/A\".  If \"Other\" is selected please explain under the Comments section.)]],\"Victim expressly indicated that no further forensic examination or testing be performed on the kit\")-1","v":0}]
[null,"# Still Requiring Testing",{"$f":"C6-(C7+C8+C9+C10)","v":0}]

{"sheet":"Cell References","index":4,"n_rows":24,"n_cols":1,"rows_kept":24,"hidden":true}
["Forensic Laboratories"]
[]
["Idaho State Police"]
["Federal Bureau of Investigation"]
["Other Government Laboratory"]
["Private Laboratory"]
[]
["Completed or In Progress"]
[]
["Completed"]
["In Progress"]
[]
["Yes or No"]
[]
["Yes"]
["No"]
["N/A"]
[]
["Reason Not Submitted"]
[]
["Law enforcment determined no crime was committed"]
["Law enforcement is no longer investigating as a crime"]
["Victim expressly indicated that no further forensic examination or testing be performed on the kit"]
["Other"]